本文|版权所有_javaweb开发（mybatis编程）

篇首语：本文由编程笔记#小编为大家整理，主要介绍了java web开发（mybatis编程）相关的知识，希望对你有一定的参考价值。

【 声明&＃xff1a;版权所有&＃xff0c;欢迎转载&＃xff0c;请勿用于商业用途。 联系信箱&＃xff1a;feixiaoxing &＃64;163.com】

        目前java web标准的开发模式是ssm&＃xff0c;前面两个s就是我们熟悉的spring和spring mvc。至于m&＃xff0c;就是今天要聊的mybatis。使用mybatis&＃xff0c;既需要使用配置文件mybatis-config.xml&＃xff0c;也需要把sql语句写到***Dao.xml文件中。这就是它和hibernate不一样的地方。

        本文主要参考了两个链接&＃xff0c;分别是链接1https://blog.csdn.net/aaa958099161/article/details/108098946&＃xff0c;链接2https://juejin.cn/post/7042311420561588260&＃xff0c;在此一并表示感谢。

        下面&＃xff0c;就可以描述一下应该如何配置和使用mybatis。

1、利用IDEA&＃43;maven创建一个maven-archetype-quickstart工程

2、工程命名为Hello&＃xff0c;不停单击Next&＃xff0c;直到工程创建结束

3、修改pom.xml文件

3.1 添加依赖


org.mybatis
mybatis
3.4.5


mysql
mysql-connector-java
5.1.47


 3.2 在build下的pluginManagement后面添加资源说明



src/main/resources

**/*.properties
**/*.xml

false


src/main/java

**/*.properties
**/*.xml

false




4、创建数据库java_web&＃xff0c;并且创建一个user.sql导入表&＃xff0c;表的内容如下所示&＃xff0c;


CREATE TABLE &＃96;user&＃96; (

&＃96;id&＃96; int(11) NOT NULL AUTO_INCREMENT,

&＃96;name&＃96; varchar(50) NOT NULL,

&＃96;birthday&＃96; datetime DEFAULT NULL,

&＃96;sex&＃96; varchar(1) DEFAULT NULL,

&＃96;address&＃96; varchar(50) DEFAULT NULL,

PRIMARY KEY (&＃96;id&＃96;)

) ENGINE&＃61;InnoDB AUTO_INCREMENT&＃61;3 DEFAULT CHARSET&＃61;utf8

5、添加User.java类

package org.example;
import java.io.Serializable;
import java.util.Date;
public class User implements Serializable
private Integer id;
private String name;
private Date birthday;
private String sex;
private String address;
&＃64;Override
public String toString()
return "User" &＃43;
"id&＃61;" &＃43; id &＃43;
", name&＃61;&＃39;" &＃43; name &＃43; &＃39;\\&＃39;&＃39; &＃43;
", birthday&＃61;" &＃43; birthday &＃43;
", sex&＃61;&＃39;" &＃43; sex &＃43; &＃39;\\&＃39;&＃39; &＃43;
", address&＃61;&＃39;" &＃43; address &＃43; &＃39;\\&＃39;&＃39; &＃43;
&＃39;&＃39;;

public Integer getId()
return id;

public void setId(Integer id)
this.id &＃61; id;

public String getName()
return name;

public void setName(String name)
this.name &＃61; name;

public Date getBirthday()
return birthday;

public void setBirthday(Date birthday)
this.birthday &＃61; birthday;

public String getSex()
return sex;

public void setSex(String sex)
this.sex &＃61; sex;

public String getAddress()
return address;

public void setAddress(String address)
this.address &＃61; address;



6、添加IUserDao.java类

package org.example;
import java.util.List;
public interface IUserDao
List findAll();


7、添加IUserDao.xml配置文件


PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN"
"http://mybatis.org/dtd/mybatis-3-mapper.dtd">


select * from user



        注意&＃xff0c;这个文件在mybatis-config.xml中会被引用到。

8、修改App.java文件

package org.example;
import org.apache.ibatis.io.Resources;
import org.apache.ibatis.session.SqlSession;
import org.apache.ibatis.session.SqlSessionFactory;
import org.apache.ibatis.session.SqlSessionFactoryBuilder;
import java.io.IOException;
import java.io.InputStream;
import java.util.List;
/**
* Hello world!
*
*/
public class App
public static void main( String[] args )

/* define local variable*/
InputStream in &＃61;null;
SqlSession sqlSession&＃61;null;
/* read xml file and make initial configuration */
try
in &＃61; Resources.getResourceAsStream("mybatis-config.xml");
sqlSession &＃61; new SqlSessionFactoryBuilder().build(in).openSession();
catch(IOException ioe)
return;

/* get user data from sqlSession */
IUserDao iUserDao &＃61; sqlSession.getMapper(IUserDao.class);
List list &＃61;iUserDao.findAll();
for (User user:list)
System.out.println(user);

/* database reading finished, close everything peacefully */
try
in.close();
catch(IOException ioe)
System.out.println("exception happened in in.close()");

finally
sqlSession.close();




9、在src/main下面创建resources目录&＃xff0c;创建mybatis-config.xml文件


PUBLIC "-//mybatis.org//DTD Config 3.0//EN"
"http://mybatis.org/dtd/mybatis-3-config.dtd">




















10、所有配置文件文件都准备好后&＃xff0c;结构如下所示&＃xff0c;

11、利用maven-》“Hello”-》“Lifecycle”-》“compile”进行编译

12、到了这一步&＃xff0c;就可以开始运行App.class文件了&＃xff0c;

       执行过程中&＃xff0c;如果有弹窗&＃xff0c;选择“Hello”即可&＃xff0c;

       不出意外的话&＃xff0c;就可以看到这样的打印信息&＃xff0c;

"C:\\Program Files (x86)\\Java\\jdk1.8.0_91\\bin\\java.exe" "-javaagent:C:\\Program Files\\JetBrains\\IntelliJ IDEA 2020.1.1\\lib\\idea_rt.jar&＃61;59510:C:\\Program Files\\JetBrains\\IntelliJ IDEA 2020.1.1\\bin" -Dfile.encoding&＃61;UTF-8 -classpath "C:\\Program Files (x86)\\Java\\jdk1.8.0_91\\jre\\lib\\charsets.jar;C:\\Program Files (x86)\\Java\\jdk1.8.0_91\\jre\\lib\\deploy.jar;C:\\Program Files (x86)\\Java\\jdk1.8.0_91\\jre\\lib\\ext\\access-bridge-32.jar;C:\\Program Files (x86)\\Java\\jdk1.8.0_91\\jre\\lib\\ext\\cldrdata.jar;C:\\Program Files (x86)\\Java\\jdk1.8.0_91\\jre\\lib\\ext\\dnsns.jar;C:\\Program Files (x86)\\Java\\jdk1.8.0_91\\jre\\lib\\ext\\jaccess.jar;C:\\Program Files (x86)\\Java\\jdk1.8.0_91\\jre\\lib\\ext\\jfxrt.jar;C:\\Program Files (x86)\\Java\\jdk1.8.0_91\\jre\\lib\\ext\\localedata.jar;C:\\Program Files (x86)\\Java\\jdk1.8.0_91\\jre\\lib\\ext\\nashorn.jar;C:\\Program Files (x86)\\Java\\jdk1.8.0_91\\jre\\lib\\ext\\sunec.jar;C:\\Program Files (x86)\\Java\\jdk1.8.0_91\\jre\\lib\\ext\\sunjce_provider.jar;C:\\Program Files (x86)\\Java\\jdk1.8.0_91\\jre\\lib\\ext\\sunmscapi.jar;C:\\Program Files (x86)\\Java\\jdk1.8.0_91\\jre\\lib\\ext\\sunpkcs11.jar;C:\\Program Files (x86)\\Java\\jdk1.8.0_91\\jre\\lib\\ext\\zipfs.jar;C:\\Program Files (x86)\\Java\\jdk1.8.0_91\\jre\\lib\\javaws.jar;C:\\Program Files (x86)\\Java\\jdk1.8.0_91\\jre\\lib\\jce.jar;C:\\Program Files (x86)\\Java\\jdk1.8.0_91\\jre\\lib\\jfr.jar;C:\\Program Files (x86)\\Java\\jdk1.8.0_91\\jre\\lib\\jfxswt.jar;C:\\Program Files (x86)\\Java\\jdk1.8.0_91\\jre\\lib\\jsse.jar;C:\\Program Files (x86)\\Java\\jdk1.8.0_91\\jre\\lib\\management-agent.jar;C:\\Program Files (x86)\\Java\\jdk1.8.0_91\\jre\\lib\\plugin.jar;C:\\Program Files (x86)\\Java\\jdk1.8.0_91\\jre\\lib\\resources.jar;C:\\Program Files (x86)\\Java\\jdk1.8.0_91\\jre\\lib\\rt.jar;C:\\Users\\feixiaoxing\\Desktop\\Hello\\target\\classes;D:\\software\\apache-maven-3.6.3-bin\\repository\\org\\mybatis\\mybatis\\3.4.5\\mybatis-3.4.5.jar;D:\\software\\apache-maven-3.6.3-bin\\repository\\mysql\\mysql-connector-java\\5.1.47\\mysql-connector-java-5.1.47.jar" org.example.App
Sat Oct 08 06:52:56 CST 2022 WARN: Establishing SSL connection without server&＃39;s identity verification is not recommended. According to MySQL 5.5.45&＃43;, 5.6.26&＃43; and 5.7.6&＃43; requirements SSL connection must be established by default if explicit option isn&＃39;t set. For compliance with existing applications not using SSL the verifyServerCertificate property is set to &＃39;false&＃39;. You need either to explicitly disable SSL by setting useSSL&＃61;false, or set useSSL&＃61;true and provide truststore for server certificate verification.
Userid&＃61;1, name&＃61;&＃39;tom&＃39;, birthday&＃61;Sat Oct 08 06:13:03 CST 2022, sex&＃61;&＃39;m&＃39;, address&＃61;&＃39;china&＃39;
Process finished with exit code 0


        注意&＃xff0c;数据是自己在数据库里面添加的&＃xff0c;显示的内容由自己来设定的。